package com.mapper;

import com.pojo.Worker;
import org.apache.ibatis.annotations.*;

/**
* @author ACER
* @description 针对表【tb_worker】的数据库操作Mapper
* @createDate 2024-11-15 08:28:46
* @Entity com.pojo.Worker
*/
public interface WorkerMapper {

    int deleteByPrimaryKey(Long id);

    int insert(Worker record);

    int insertSelective(Worker record);

    Worker selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Worker record);

    int updateByPrimaryKey(Worker record);
@Select("select  * from tb_worker where id=#{id}")
    Worker selectWorker(Long id);
@Insert("insert into tb_worker(name,age,sex,worker_id)values (#{name},#{age},#{sex},#{workerId})")
    int insertWorker(Worker worker);
@Update("update tb_worker set name=#{name},age=#{age}"+"where id=#{id}")
    int updateWorker(Worker worker);
@Delete("delete from tb_worker id=#{id}")
    int deleteWorker(int id);
@Select("select *from tb_worder id=#{param01} and name=#{param02}")
    Worker selectWorkerByIdAndName(@Param("param01")int id, @Param("param02")String name);
}
